<?php
/**
 * @author bbernath
 *         Date: 09.10.13
 *         Time: 11:21
 * @version 1.0.3
 */

echo "<h3>&raquo; Team</h3>";
?>

Hier eine kurze &Uuml;bersicht von unserem Team.

<br><br>

<?php
$sql = "select name, title, passion, pic_link, additional_title from team";
$stmt = $db->prepare($sql);
$stmt->execute();
$stmt->bind_result($name, $title, $passion, $pic_link, $additional_title);
$team = array();
while ($stmt->fetch()) {
    $team[] = array(
        'name' => $name,
        'title' => $title,
        'passion' => $passion,
        'pic_link' => $pic_link,
        'additional_title' => $additional_title
    );
}
$stmt->close();
?>

<table border="1" id="team">
    <?php
    foreach ($team as $member) {
        echo "<tr><td><b>" . $member['additional_title'] . "</b></td>";
        echo "<td>" . $member['name'] . "</td>";
        echo "<td rowspan='3'><img src='" . $member['pic_link'] . "' height='150' width='112'></td></tr>";
        echo "<tr><td><b>Titel:</b></td><td>" . $member['title'] . "</td></tr>";
        echo "<tr><td><b>Leidenschaft:</b></td><td>" . $member['passion'] . "</td></tr>";
        echo "<tr><td colspan=3><br><br></td></tr>";
    }
    ?>
</table>